﻿-- Module
IF NOT EXISTS( SELECT NULL  FROM medianamik_Node where NodeId = '6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78')  BEGIN  INSERT INTO [dbo].[medianamik_Node]             ([NodeId]             ,[ParentNodeId]             ,[TypeId]             ,[CreatedOn]             ,[CreatedBy]             ,[ModifiedOn]             ,[ModifiedBy]             ,[Flags]             ,[IsDeleted]             ,[Path]             ,[Depth]             ,[Position]             ,[EditedOn]             ,[EditedBy])       VALUES             ('6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78'             ,NULL                        ,'627E47FC-6C91-444F-B3A6-79B1F687EF9A'             ,'2009-07-02 12:55:18.617'             ,''             ,'2009-07-02 12:55:18.617'             ,''             ,         0             ,         0             ,'.6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78.'             ,         0             ,         0             ,'2009-07-02 12:55:18.617'             ,'sa'             )  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78' AND CultureNAme = 'en-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('77CF320D-1F17-4C3B-A7AB-9CEFD00300E4'             ,'6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78'             ,         1             ,'2009-07-02 12:55:18.617'             ,'en-CA')  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78' AND CultureNAme = 'fr-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('4DAF8268-BE61-4775-8CD7-CCCB52F0816A'             ,'6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78'             ,         1             ,'2009-07-02 12:55:18.617'             ,'fr-CA')  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78' AND PropertyId = '5DEC52FD-25C3-4AB3-AFC7-6E1E38437FF1' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78'             ,'5DEC52FD-25C3-4AB3-AFC7-6E1E38437FF1'             ,NULL                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78' AND PropertyId = '19AE84AF-386F-41D9-ACD3-82EBB313A28F' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78'             ,'19AE84AF-386F-41D9-ACD3-82EBB313A28F'             ,'True'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78' AND PropertyId = '12179708-3E1B-4E30-A654-B762E9E3159C' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78'             ,'12179708-3E1B-4E30-A654-B762E9E3159C'             ,'forums'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78' AND PropertyId = 'B13C9212-65B3-491B-8DC7-C2E775A6D669' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78'             ,'B13C9212-65B3-491B-8DC7-C2E775A6D669'             ,''                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78' AND PropertyId = '277B7D42-8EC5-400F-8FF6-6E832A36F18C' AND CultureName = 'fr-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78'             ,'277B7D42-8EC5-400F-8FF6-6E832A36F18C'             ,'Gestion des forums'                       ,null             ,'fr-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78' AND PropertyId = '277B7D42-8EC5-400F-8FF6-6E832A36F18C' AND CultureName = 'en-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78'             ,'277B7D42-8EC5-400F-8FF6-6E832A36F18C'             ,'Forum Management'                       ,null             ,'en-CA'             ,null             )  END

-- Menu
IF NOT EXISTS( SELECT NULL  FROM medianamik_Node where NodeId = '6C5CB8E3-9661-45AF-9079-71919F7A085B')  BEGIN  INSERT INTO [dbo].[medianamik_Node]             ([NodeId]             ,[ParentNodeId]             ,[TypeId]             ,[CreatedOn]             ,[CreatedBy]             ,[ModifiedOn]             ,[ModifiedBy]             ,[Flags]             ,[IsDeleted]             ,[Path]             ,[Depth]             ,[Position]             ,[EditedOn]             ,[EditedBy])       VALUES             ('6C5CB8E3-9661-45AF-9079-71919F7A085B'             ,'7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0'                        ,'C0B56F78-44EB-4E20-A1A8-3E0D56F008A3'             ,'2009-07-02 13:18:23.860'             ,''             ,'2009-07-02 13:18:23.860'             ,''             ,         0             ,         0             ,'.7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0.6C5CB8E3-9661-45AF-9079-71919F7A085B.'             ,         1             ,       189             ,'2009-07-02 13:18:23.860'             ,'sa'             )  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '6C5CB8E3-9661-45AF-9079-71919F7A085B' AND CultureNAme = 'en-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('25A0F67D-A677-403D-8C2B-6278AFEDB514'             ,'6C5CB8E3-9661-45AF-9079-71919F7A085B'             ,         1             ,'2009-07-02 13:18:23.860'             ,'en-CA')  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '6C5CB8E3-9661-45AF-9079-71919F7A085B' AND CultureNAme = 'fr-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('4BABFF5D-D12C-48E5-A86F-DC71988B998B'             ,'6C5CB8E3-9661-45AF-9079-71919F7A085B'             ,         1             ,'2009-07-02 13:18:23.860'             ,'fr-CA')  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6C5CB8E3-9661-45AF-9079-71919F7A085B' AND PropertyId = '201FEBF3-7255-46F1-9E10-0E2A761DA79A' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6C5CB8E3-9661-45AF-9079-71919F7A085B'             ,'201FEBF3-7255-46F1-9E10-0E2A761DA79A'             ,'/medianamik/images/Menu_ConfigurationsAdministratives-over.png'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6C5CB8E3-9661-45AF-9079-71919F7A085B' AND PropertyId = '8CBBBD5C-CE8D-4314-8760-691585FD3572' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6C5CB8E3-9661-45AF-9079-71919F7A085B'             ,'8CBBBD5C-CE8D-4314-8760-691585FD3572'             ,NULL                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6C5CB8E3-9661-45AF-9079-71919F7A085B' AND PropertyId = '1D1112F0-5773-4186-9CF7-7B2FF16AC548' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6C5CB8E3-9661-45AF-9079-71919F7A085B'             ,'1D1112F0-5773-4186-9CF7-7B2FF16AC548'             ,'/medianamik/images/Menu_ConfigurationsAdministratives.png'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6C5CB8E3-9661-45AF-9079-71919F7A085B' AND PropertyId = '777E535E-66E6-4CB4-A066-C200D4B9C5E0' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6C5CB8E3-9661-45AF-9079-71919F7A085B'             ,'777E535E-66E6-4CB4-A066-C200D4B9C5E0'             ,'/medianamik/images/Icones/Ico_AccGestionPages.png'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6C5CB8E3-9661-45AF-9079-71919F7A085B' AND PropertyId = '9E14DDE8-DA4C-4385-BDA2-A295A0F954E6' AND CultureName = 'fr-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6C5CB8E3-9661-45AF-9079-71919F7A085B'             ,'9E14DDE8-DA4C-4385-BDA2-A295A0F954E6'             ,'Gestion des forums'                       ,null             ,'fr-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6C5CB8E3-9661-45AF-9079-71919F7A085B' AND PropertyId = '9E14DDE8-DA4C-4385-BDA2-A295A0F954E6' AND CultureName = 'en-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6C5CB8E3-9661-45AF-9079-71919F7A085B'             ,'9E14DDE8-DA4C-4385-BDA2-A295A0F954E6'             ,'Forum Management'                       ,null             ,'en-CA'             ,null             )  END

---- Pages ---
-- Créer / Éditer un utilisateur
IF NOT EXISTS( SELECT NULL  FROM medianamik_Node where NodeId = '65E6509D-09D8-4B73-B6E8-F5AFFD44F370')  BEGIN  INSERT INTO [dbo].[medianamik_Node]             ([NodeId]             ,[ParentNodeId]             ,[TypeId]             ,[CreatedOn]             ,[CreatedBy]             ,[ModifiedOn]             ,[ModifiedBy]             ,[Flags]             ,[IsDeleted]             ,[Path]             ,[Depth]             ,[Position]             ,[EditedOn]             ,[EditedBy])       VALUES             ('65E6509D-09D8-4B73-B6E8-F5AFFD44F370'             ,'7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0'                        ,'3DAD4D08-B9BC-4603-A8DE-42A88A354B5B'             ,'2009-07-31 08:50:56.007'             ,''             ,'2009-07-31 08:53:06.087'             ,''             ,         0             ,         0             ,'.7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0.65E6509D-09D8-4B73-B6E8-F5AFFD44F370.'             ,         1             ,         0             ,'2009-07-31 08:53:06.087'             ,'sa'             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '65E6509D-09D8-4B73-B6E8-F5AFFD44F370' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = 'en-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('65E6509D-09D8-4B73-B6E8-F5AFFD44F370'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,'Create / Edit Forum'                       ,null             ,'en-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '65E6509D-09D8-4B73-B6E8-F5AFFD44F370' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = 'fr-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('65E6509D-09D8-4B73-B6E8-F5AFFD44F370'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,'Créer / Éditer un utilisateur'                       ,null             ,'fr-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '65E6509D-09D8-4B73-B6E8-F5AFFD44F370' AND PropertyId = '29571C7C-3B7A-4576-8BB0-F2EAF8413D20' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('65E6509D-09D8-4B73-B6E8-F5AFFD44F370'             ,'29571C7C-3B7A-4576-8BB0-F2EAF8413D20'             ,'False'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '65E6509D-09D8-4B73-B6E8-F5AFFD44F370' AND PropertyId = '47096ACE-4C51-4C8F-BAE2-15A6FD90F6E9' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('65E6509D-09D8-4B73-B6E8-F5AFFD44F370'             ,'47096ACE-4C51-4C8F-BAE2-15A6FD90F6E9'             ,'forumusermanagement.aspx'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '65E6509D-09D8-4B73-B6E8-F5AFFD44F370' AND PropertyId = '60C0AA24-C355-4722-ACAA-21D363351479' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('65E6509D-09D8-4B73-B6E8-F5AFFD44F370'             ,'60C0AA24-C355-4722-ACAA-21D363351479'             ,'6c5cb8e3-9661-45af-9079-71919f7a085b'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '65E6509D-09D8-4B73-B6E8-F5AFFD44F370' AND PropertyId = '7213C44C-BBC7-4095-AE52-0DE37E7276C7' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('65E6509D-09D8-4B73-B6E8-F5AFFD44F370'             ,'7213C44C-BBC7-4095-AE52-0DE37E7276C7'             ,'True'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '65E6509D-09D8-4B73-B6E8-F5AFFD44F370' AND PropertyId = 'A5F1D87F-3086-4CEA-A983-A09D4FE9FC4C' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('65E6509D-09D8-4B73-B6E8-F5AFFD44F370'             ,'A5F1D87F-3086-4CEA-A983-A09D4FE9FC4C'             ,'6c09a5b6-d454-4bfa-be7d-3aa1bb57ab78'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '65E6509D-09D8-4B73-B6E8-F5AFFD44F370' AND PropertyId = 'A9D96D60-4E0D-4EF6-831C-AAD02A1D2BCF' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('65E6509D-09D8-4B73-B6E8-F5AFFD44F370'             ,'A9D96D60-4E0D-4EF6-831C-AAD02A1D2BCF'             ,'True'                       ,null             ,''             ,null             )  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '65E6509D-09D8-4B73-B6E8-F5AFFD44F370' AND CultureNAme = 'en-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('EAEEDA65-10D1-4545-A5FC-58841EB8A88D'             ,'65E6509D-09D8-4B73-B6E8-F5AFFD44F370'             ,         1             ,'2009-07-31 08:50:56.023'             ,'en-CA')  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '65E6509D-09D8-4B73-B6E8-F5AFFD44F370' AND CultureNAme = 'fr-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('81045422-C68E-45F6-BF43-A585CA150D4C'             ,'65E6509D-09D8-4B73-B6E8-F5AFFD44F370'             ,         1             ,'2009-07-31 08:50:56.023'             ,'fr-CA')  END

-- Gestion des utilisateurs
IF NOT EXISTS( SELECT NULL  FROM medianamik_Node where NodeId = '913BB12C-76C1-4B23-BADC-AD74FA7599B4')  BEGIN  INSERT INTO [dbo].[medianamik_Node]             ([NodeId]             ,[ParentNodeId]             ,[TypeId]             ,[CreatedOn]             ,[CreatedBy]             ,[ModifiedOn]             ,[ModifiedBy]             ,[Flags]             ,[IsDeleted]             ,[Path]             ,[Depth]             ,[Position]             ,[EditedOn]             ,[EditedBy])       VALUES             ('913BB12C-76C1-4B23-BADC-AD74FA7599B4'             ,'7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0'                        ,'3DAD4D08-B9BC-4603-A8DE-42A88A354B5B'             ,'2009-07-30 14:48:43.487'             ,''             ,'2009-07-30 14:48:43.487'             ,''             ,         0             ,         0             ,'.7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0.913BB12C-76C1-4B23-BADC-AD74FA7599B4.'             ,         1             ,         1             ,'2009-07-30 14:48:43.487'             ,'sa'             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '913BB12C-76C1-4B23-BADC-AD74FA7599B4' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = 'en-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('913BB12C-76C1-4B23-BADC-AD74FA7599B4'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,'Users Management'                       ,null             ,'en-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '913BB12C-76C1-4B23-BADC-AD74FA7599B4' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = 'fr-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('913BB12C-76C1-4B23-BADC-AD74FA7599B4'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,'Gestion des utilisateurs'                       ,null             ,'fr-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '913BB12C-76C1-4B23-BADC-AD74FA7599B4' AND PropertyId = '29571C7C-3B7A-4576-8BB0-F2EAF8413D20' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('913BB12C-76C1-4B23-BADC-AD74FA7599B4'             ,'29571C7C-3B7A-4576-8BB0-F2EAF8413D20'             ,'True'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '913BB12C-76C1-4B23-BADC-AD74FA7599B4' AND PropertyId = '47096ACE-4C51-4C8F-BAE2-15A6FD90F6E9' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('913BB12C-76C1-4B23-BADC-AD74FA7599B4'             ,'47096ACE-4C51-4C8F-BAE2-15A6FD90F6E9'             ,'forumuserlist.aspx'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '913BB12C-76C1-4B23-BADC-AD74FA7599B4' AND PropertyId = '60C0AA24-C355-4722-ACAA-21D363351479' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('913BB12C-76C1-4B23-BADC-AD74FA7599B4'             ,'60C0AA24-C355-4722-ACAA-21D363351479'             ,'6c5cb8e3-9661-45af-9079-71919f7a085b'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '913BB12C-76C1-4B23-BADC-AD74FA7599B4' AND PropertyId = '7213C44C-BBC7-4095-AE52-0DE37E7276C7' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('913BB12C-76C1-4B23-BADC-AD74FA7599B4'             ,'7213C44C-BBC7-4095-AE52-0DE37E7276C7'             ,'False'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '913BB12C-76C1-4B23-BADC-AD74FA7599B4' AND PropertyId = 'A5F1D87F-3086-4CEA-A983-A09D4FE9FC4C' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('913BB12C-76C1-4B23-BADC-AD74FA7599B4'             ,'A5F1D87F-3086-4CEA-A983-A09D4FE9FC4C'             ,'6c09a5b6-d454-4bfa-be7d-3aa1bb57ab78'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '913BB12C-76C1-4B23-BADC-AD74FA7599B4' AND PropertyId = 'A9D96D60-4E0D-4EF6-831C-AAD02A1D2BCF' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('913BB12C-76C1-4B23-BADC-AD74FA7599B4'             ,'A9D96D60-4E0D-4EF6-831C-AAD02A1D2BCF'             ,'True'                       ,null             ,''             ,null             )  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '913BB12C-76C1-4B23-BADC-AD74FA7599B4' AND CultureNAme = 'en-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('16740C25-D603-4745-96F1-47678318D180'             ,'913BB12C-76C1-4B23-BADC-AD74FA7599B4'             ,         1             ,'2009-07-30 14:48:43.487'             ,'en-CA')  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '913BB12C-76C1-4B23-BADC-AD74FA7599B4' AND CultureNAme = 'fr-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('F83C584C-724E-4F54-8057-4C7ECC8CE3E3'             ,'913BB12C-76C1-4B23-BADC-AD74FA7599B4'             ,         1             ,'2009-07-30 14:48:43.487'             ,'fr-CA')  END

-- Configuration de forum
IF NOT EXISTS( SELECT NULL  FROM medianamik_Node where NodeId = '6F92B0F8-AB84-4961-B312-718444F8EC05')  BEGIN  INSERT INTO [dbo].[medianamik_Node]             ([NodeId]             ,[ParentNodeId]             ,[TypeId]             ,[CreatedOn]             ,[CreatedBy]             ,[ModifiedOn]             ,[ModifiedBy]             ,[Flags]             ,[IsDeleted]             ,[Path]             ,[Depth]             ,[Position]             ,[EditedOn]             ,[EditedBy])       VALUES             ('6F92B0F8-AB84-4961-B312-718444F8EC05'             ,'7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0'                        ,'3DAD4D08-B9BC-4603-A8DE-42A88A354B5B'             ,'2009-07-17 14:05:03.983'             ,''             ,'2009-07-17 14:07:02.733'             ,''             ,         0             ,         0             ,'.7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0.6F92B0F8-AB84-4961-B312-718444F8EC05.'             ,         1             ,         4             ,'2009-07-17 14:07:02.733'             ,'sa'             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6F92B0F8-AB84-4961-B312-718444F8EC05' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = 'en-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6F92B0F8-AB84-4961-B312-718444F8EC05'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,'Forum Configuration'                       ,null             ,'en-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6F92B0F8-AB84-4961-B312-718444F8EC05' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = 'fr-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6F92B0F8-AB84-4961-B312-718444F8EC05'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,'Configuration de forum'                       ,null             ,'fr-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6F92B0F8-AB84-4961-B312-718444F8EC05' AND PropertyId = '29571C7C-3B7A-4576-8BB0-F2EAF8413D20' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6F92B0F8-AB84-4961-B312-718444F8EC05'             ,'29571C7C-3B7A-4576-8BB0-F2EAF8413D20'             ,'False'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6F92B0F8-AB84-4961-B312-718444F8EC05' AND PropertyId = '47096ACE-4C51-4C8F-BAE2-15A6FD90F6E9' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6F92B0F8-AB84-4961-B312-718444F8EC05'             ,'47096ACE-4C51-4C8F-BAE2-15A6FD90F6E9'             ,'ForumConfigurationManagement.aspx'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6F92B0F8-AB84-4961-B312-718444F8EC05' AND PropertyId = '60C0AA24-C355-4722-ACAA-21D363351479' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6F92B0F8-AB84-4961-B312-718444F8EC05'             ,'60C0AA24-C355-4722-ACAA-21D363351479'             ,'6c5cb8e3-9661-45af-9079-71919f7a085b'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6F92B0F8-AB84-4961-B312-718444F8EC05' AND PropertyId = '7213C44C-BBC7-4095-AE52-0DE37E7276C7' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6F92B0F8-AB84-4961-B312-718444F8EC05'             ,'7213C44C-BBC7-4095-AE52-0DE37E7276C7'             ,'True'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6F92B0F8-AB84-4961-B312-718444F8EC05' AND PropertyId = 'A5F1D87F-3086-4CEA-A983-A09D4FE9FC4C' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6F92B0F8-AB84-4961-B312-718444F8EC05'             ,'A5F1D87F-3086-4CEA-A983-A09D4FE9FC4C'             ,'6c09a5b6-d454-4bfa-be7d-3aa1bb57ab78'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6F92B0F8-AB84-4961-B312-718444F8EC05' AND PropertyId = 'A9D96D60-4E0D-4EF6-831C-AAD02A1D2BCF' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6F92B0F8-AB84-4961-B312-718444F8EC05'             ,'A9D96D60-4E0D-4EF6-831C-AAD02A1D2BCF'             ,'True'                       ,null             ,''             ,null             )  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '6F92B0F8-AB84-4961-B312-718444F8EC05' AND CultureNAme = 'en-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('7466B4C2-A395-4B00-A5FD-F32A55039B1A'             ,'6F92B0F8-AB84-4961-B312-718444F8EC05'             ,         1             ,'2009-07-17 14:05:03.983'             ,'en-CA')  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '6F92B0F8-AB84-4961-B312-718444F8EC05' AND CultureNAme = 'fr-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('14716522-C627-4AB2-B91B-E6A0938FD7EA'             ,'6F92B0F8-AB84-4961-B312-718444F8EC05'             ,         1             ,'2009-07-17 14:05:03.983'             ,'fr-CA')  END

-- Configurations des forums
IF NOT EXISTS( SELECT NULL  FROM medianamik_Node where NodeId = '6295CC17-3AA7-4A4F-AB7C-15F377722825')  BEGIN  INSERT INTO [dbo].[medianamik_Node]             ([NodeId]             ,[ParentNodeId]             ,[TypeId]             ,[CreatedOn]             ,[CreatedBy]             ,[ModifiedOn]             ,[ModifiedBy]             ,[Flags]             ,[IsDeleted]             ,[Path]             ,[Depth]             ,[Position]             ,[EditedOn]             ,[EditedBy])       VALUES             ('6295CC17-3AA7-4A4F-AB7C-15F377722825'             ,'7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0'                        ,'3DAD4D08-B9BC-4603-A8DE-42A88A354B5B'             ,'2009-07-13 16:00:50.350'             ,''             ,'2009-07-13 16:21:23.413'             ,''             ,         0             ,         0             ,'.7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0.6295CC17-3AA7-4A4F-AB7C-15F377722825.'             ,         1             ,         5             ,'2009-07-13 16:21:23.413'             ,'sa'             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6295CC17-3AA7-4A4F-AB7C-15F377722825' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = 'en-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6295CC17-3AA7-4A4F-AB7C-15F377722825'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,'Forums Configurations'                       ,null             ,'en-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6295CC17-3AA7-4A4F-AB7C-15F377722825' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = 'fr-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6295CC17-3AA7-4A4F-AB7C-15F377722825'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,'Configurations des forums'                       ,null             ,'fr-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6295CC17-3AA7-4A4F-AB7C-15F377722825' AND PropertyId = '29571C7C-3B7A-4576-8BB0-F2EAF8413D20' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6295CC17-3AA7-4A4F-AB7C-15F377722825'             ,'29571C7C-3B7A-4576-8BB0-F2EAF8413D20'             ,'True'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6295CC17-3AA7-4A4F-AB7C-15F377722825' AND PropertyId = '47096ACE-4C51-4C8F-BAE2-15A6FD90F6E9' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6295CC17-3AA7-4A4F-AB7C-15F377722825'             ,'47096ACE-4C51-4C8F-BAE2-15A6FD90F6E9'             ,'ForumConfigurationList.aspx'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6295CC17-3AA7-4A4F-AB7C-15F377722825' AND PropertyId = '60C0AA24-C355-4722-ACAA-21D363351479' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6295CC17-3AA7-4A4F-AB7C-15F377722825'             ,'60C0AA24-C355-4722-ACAA-21D363351479'             ,'6c5cb8e3-9661-45af-9079-71919f7a085b'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6295CC17-3AA7-4A4F-AB7C-15F377722825' AND PropertyId = '7213C44C-BBC7-4095-AE52-0DE37E7276C7' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6295CC17-3AA7-4A4F-AB7C-15F377722825'             ,'7213C44C-BBC7-4095-AE52-0DE37E7276C7'             ,'False'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6295CC17-3AA7-4A4F-AB7C-15F377722825' AND PropertyId = 'A5F1D87F-3086-4CEA-A983-A09D4FE9FC4C' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6295CC17-3AA7-4A4F-AB7C-15F377722825'             ,'A5F1D87F-3086-4CEA-A983-A09D4FE9FC4C'             ,'6c09a5b6-d454-4bfa-be7d-3aa1bb57ab78'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '6295CC17-3AA7-4A4F-AB7C-15F377722825' AND PropertyId = 'A9D96D60-4E0D-4EF6-831C-AAD02A1D2BCF' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('6295CC17-3AA7-4A4F-AB7C-15F377722825'             ,'A9D96D60-4E0D-4EF6-831C-AAD02A1D2BCF'             ,'True'                       ,null             ,''             ,null             )  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '6295CC17-3AA7-4A4F-AB7C-15F377722825' AND CultureNAme = 'en-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('E23B851E-3CEA-4307-8307-C11542DA2964'             ,'6295CC17-3AA7-4A4F-AB7C-15F377722825'             ,         1             ,'2009-07-13 16:00:50.350'             ,'en-CA')  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '6295CC17-3AA7-4A4F-AB7C-15F377722825' AND CultureNAme = 'fr-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('1E0C596E-AD24-46D1-A914-9C74A0CB362B'             ,'6295CC17-3AA7-4A4F-AB7C-15F377722825'             ,         1             ,'2009-07-13 16:00:50.350'             ,'fr-CA')  END

-- Gestion des forums
IF NOT EXISTS( SELECT NULL  FROM medianamik_Node where NodeId = 'A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B')  BEGIN  INSERT INTO [dbo].[medianamik_Node]             ([NodeId]             ,[ParentNodeId]             ,[TypeId]             ,[CreatedOn]             ,[CreatedBy]             ,[ModifiedOn]             ,[ModifiedBy]             ,[Flags]             ,[IsDeleted]             ,[Path]             ,[Depth]             ,[Position]             ,[EditedOn]             ,[EditedBy])       VALUES             ('A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B'             ,'7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0'                        ,'3DAD4D08-B9BC-4603-A8DE-42A88A354B5B'             ,'2009-07-08 12:52:19.513'             ,''             ,'2009-07-08 12:52:19.513'             ,''             ,         0             ,         0             ,'.7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0.A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B.'             ,         1             ,         6             ,'2009-07-08 12:52:19.513'             ,'sa'             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = 'en-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,'Forum Management'                       ,null             ,'en-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = 'fr-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,'Gestion des forums'                       ,null             ,'fr-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B' AND PropertyId = '29571C7C-3B7A-4576-8BB0-F2EAF8413D20' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B'             ,'29571C7C-3B7A-4576-8BB0-F2EAF8413D20'             ,'False'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B' AND PropertyId = '47096ACE-4C51-4C8F-BAE2-15A6FD90F6E9' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B'             ,'47096ACE-4C51-4C8F-BAE2-15A6FD90F6E9'             ,'forummanagement.aspx'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B' AND PropertyId = '60C0AA24-C355-4722-ACAA-21D363351479' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B'             ,'60C0AA24-C355-4722-ACAA-21D363351479'             ,'6c5cb8e3-9661-45af-9079-71919f7a085b'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B' AND PropertyId = '7213C44C-BBC7-4095-AE52-0DE37E7276C7' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B'             ,'7213C44C-BBC7-4095-AE52-0DE37E7276C7'             ,'True'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B' AND PropertyId = 'A5F1D87F-3086-4CEA-A983-A09D4FE9FC4C' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B'             ,'A5F1D87F-3086-4CEA-A983-A09D4FE9FC4C'             ,'6c09a5b6-d454-4bfa-be7d-3aa1bb57ab78'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B' AND PropertyId = 'A9D96D60-4E0D-4EF6-831C-AAD02A1D2BCF' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B'             ,'A9D96D60-4E0D-4EF6-831C-AAD02A1D2BCF'             ,'False'                       ,null             ,''             ,null             )  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = 'A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B' AND CultureNAme = 'en-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('55DAC9EF-73A1-4637-A765-DB27EBAF8E1A'             ,'A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B'             ,         1             ,'2009-07-08 12:52:19.513'             ,'en-CA')  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = 'A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B' AND CultureNAme = 'fr-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('890B7EBB-F9C1-42A5-BB9D-AA71333EED53'             ,'A8EFB1E5-0CA6-434D-B5F6-B0D5D064627B'             ,         1             ,'2009-07-08 12:52:19.513'             ,'fr-CA')  END

-- Gestion des forums
IF NOT EXISTS( SELECT NULL  FROM medianamik_Node where NodeId = '8432BAC0-95BA-49A9-AC05-5010E682F671')  BEGIN  INSERT INTO [dbo].[medianamik_Node]             ([NodeId]             ,[ParentNodeId]             ,[TypeId]             ,[CreatedOn]             ,[CreatedBy]             ,[ModifiedOn]             ,[ModifiedBy]             ,[Flags]             ,[IsDeleted]             ,[Path]             ,[Depth]             ,[Position]             ,[EditedOn]             ,[EditedBy])       VALUES             ('8432BAC0-95BA-49A9-AC05-5010E682F671'             ,'7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0'                        ,'3DAD4D08-B9BC-4603-A8DE-42A88A354B5B'             ,'2009-07-02 13:21:42.120'             ,''             ,'2009-07-02 13:21:42.120'             ,''             ,         0             ,         0             ,'.7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0.8432BAC0-95BA-49A9-AC05-5010E682F671.'             ,         1             ,         7             ,'2009-07-02 13:21:42.120'             ,'sa'             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '8432BAC0-95BA-49A9-AC05-5010E682F671' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = 'en-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('8432BAC0-95BA-49A9-AC05-5010E682F671'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,'Forum Management'                       ,null             ,'en-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '8432BAC0-95BA-49A9-AC05-5010E682F671' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = 'fr-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('8432BAC0-95BA-49A9-AC05-5010E682F671'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,'Gestion des forums'                       ,null             ,'fr-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '8432BAC0-95BA-49A9-AC05-5010E682F671' AND PropertyId = '29571C7C-3B7A-4576-8BB0-F2EAF8413D20' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('8432BAC0-95BA-49A9-AC05-5010E682F671'             ,'29571C7C-3B7A-4576-8BB0-F2EAF8413D20'             ,'True'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '8432BAC0-95BA-49A9-AC05-5010E682F671' AND PropertyId = '47096ACE-4C51-4C8F-BAE2-15A6FD90F6E9' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('8432BAC0-95BA-49A9-AC05-5010E682F671'             ,'47096ACE-4C51-4C8F-BAE2-15A6FD90F6E9'             ,'forumlist.aspx'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '8432BAC0-95BA-49A9-AC05-5010E682F671' AND PropertyId = '60C0AA24-C355-4722-ACAA-21D363351479' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('8432BAC0-95BA-49A9-AC05-5010E682F671'             ,'60C0AA24-C355-4722-ACAA-21D363351479'             ,'6c5cb8e3-9661-45af-9079-71919f7a085b'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '8432BAC0-95BA-49A9-AC05-5010E682F671' AND PropertyId = '7213C44C-BBC7-4095-AE52-0DE37E7276C7' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('8432BAC0-95BA-49A9-AC05-5010E682F671'             ,'7213C44C-BBC7-4095-AE52-0DE37E7276C7'             ,'False'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '8432BAC0-95BA-49A9-AC05-5010E682F671' AND PropertyId = 'A5F1D87F-3086-4CEA-A983-A09D4FE9FC4C' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('8432BAC0-95BA-49A9-AC05-5010E682F671'             ,'A5F1D87F-3086-4CEA-A983-A09D4FE9FC4C'             ,'6c09a5b6-d454-4bfa-be7d-3aa1bb57ab78'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '8432BAC0-95BA-49A9-AC05-5010E682F671' AND PropertyId = 'A9D96D60-4E0D-4EF6-831C-AAD02A1D2BCF' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('8432BAC0-95BA-49A9-AC05-5010E682F671'             ,'A9D96D60-4E0D-4EF6-831C-AAD02A1D2BCF'             ,'False'                       ,null             ,''             ,null             )  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '8432BAC0-95BA-49A9-AC05-5010E682F671' AND CultureNAme = 'en-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('08B19AD8-ED85-4FA7-AA44-2EB6E0FB793A'             ,'8432BAC0-95BA-49A9-AC05-5010E682F671'             ,         1             ,'2009-07-02 13:21:42.120'             ,'en-CA')  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '8432BAC0-95BA-49A9-AC05-5010E682F671' AND CultureNAme = 'fr-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('80BF1398-6DAF-484E-83D4-91BE472EA24E'             ,'8432BAC0-95BA-49A9-AC05-5010E682F671'             ,         1             ,'2009-07-02 13:21:42.120'             ,'fr-CA')  END



-- Forum configuration 
IF NOT EXISTS( SELECT NULL  FROM medianamik_Type where TypeId = '51E1110E-F0D4-4142-BD58-131C67BEA2A2')  BEGIN  INSERT INTO [dbo].[medianamik_Type]             ([TypeId]             ,[ParentTypeId]             ,[Name]             ,[CanHaveChilds]             ,[IsGenerated]             ,[IsManyToMany]             ,[Path]             ,[Depth]             ,[Roles]             ,[Flags]             ,[Description]             ,[ExtendedProperties]             ,[IsSystem]             ,[IsAbstract])       VALUES             ('51E1110E-F0D4-4142-BD58-131C67BEA2A2'             ,'51942F57-8542-4D47-8E18-533BCDA9E4B6'             ,'ForumConfiguration'             ,         0             ,         0             ,         0             ,'.51942F57-8542-4D47-8E18-533BCDA9E4B6.51E1110E-F0D4-4142-BD58-131C67BEA2A2.'             ,         1     ,NULL     ,         0             ,''     ,'<ExtendedProperties><Icon/></ExtendedProperties>'            ,         0     ,         0             )  END

-- Base Forum
IF NOT EXISTS( SELECT NULL  FROM medianamik_Type where TypeId = 'F995444B-D7E2-4C3A-8F34-81953F1F1A42')  BEGIN  INSERT INTO [dbo].[medianamik_Type]             ([TypeId]             ,[ParentTypeId]             ,[Name]             ,[CanHaveChilds]             ,[IsGenerated]             ,[IsManyToMany]             ,[Path]             ,[Depth]             ,[Roles]             ,[Flags]             ,[Description]             ,[ExtendedProperties]             ,[IsSystem]             ,[IsAbstract])       VALUES             ('F995444B-D7E2-4C3A-8F34-81953F1F1A42'             ,'6A8FFFBC-03BE-4D06-9B98-CF2A093C4505'             ,'BaseForum'             ,         1             ,         0             ,         0             ,'.51942F57-8542-4D47-8E18-533BCDA9E4B6.30BA97AB-C437-4C85-8D9D-77FB428D3D16.F7757F24-42C8-4B50-8910-0828F8C8B96D.6A8FFFBC-03BE-4D06-9B98-CF2A093C4505.F995444B-D7E2-4C3A-8F34-81953F1F1A42.'             ,         4     ,NULL     ,         1             ,''     ,'<ExtendedProperties><Icon/></ExtendedProperties>'            ,         0     ,         1             )  END

-- Forum
IF NOT EXISTS( SELECT NULL  FROM medianamik_Type where TypeId = '0878439B-D784-4AB4-8104-28FB68263AA2')  BEGIN  INSERT INTO [dbo].[medianamik_Type]             ([TypeId]             ,[ParentTypeId]             ,[Name]             ,[CanHaveChilds]             ,[IsGenerated]             ,[IsManyToMany]             ,[Path]             ,[Depth]             ,[Roles]             ,[Flags]             ,[Description]             ,[ExtendedProperties]             ,[IsSystem]             ,[IsAbstract])       VALUES             ('0878439B-D784-4AB4-8104-28FB68263AA2'             ,'F995444B-D7E2-4C3A-8F34-81953F1F1A42'             ,'Forum'             ,         1             ,         1             ,         0             ,'.51942F57-8542-4D47-8E18-533BCDA9E4B6.30BA97AB-C437-4C85-8D9D-77FB428D3D16.F7757F24-42C8-4B50-8910-0828F8C8B96D.6A8FFFBC-03BE-4D06-9B98-CF2A093C4505.F995444B-D7E2-4C3A-8F34-81953F1F1A42.0878439B-D784-4AB4-8104-28FB68263AA2.'             ,         5     ,NULL     ,         1             ,''     ,'<ExtendedProperties><Icon/><PropertyPositions><Property Id="35a3f17a-a4c8-4331-9e8f-10fc27c18445"/><Property Id="72a8ac9e-13d8-41f9-9684-ed101a731bc7"/><Property Id="4555c4bd-b476-4b47-943c-c4851345bfab"/><Property Id="aba46c94-62ee-4d10-b977-1c6272ead48d"/><Property Id="2fe3a895-6566-4ad0-9803-72d46c7958f5"/><Property Id="e1c5c632-c8b0-4298-8eb2-95120d2e748c"/><Property Id="ee60ce0b-94ef-43e4-80a8-f03ba59640bb"/><Property Id="ab82e960-2922-4c43-9059-f74e69f6a586"/></PropertyPositions></ExtendedProperties>'            ,         0     ,         0             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_Property where PropertyId = '4555C4BD-B476-4B47-943C-C4851345BFAB' )  BEGIN  INSERT INTO [dbo].[medianamik_Property]             ([PropertyId]             ,[TypeId]             ,[Name]             ,[HaveTooltip]             ,[IsLanguageNeutral]             ,[IsRequired]             ,[IsUnique]             ,[ValidationRegex]             ,[GroupName]             ,[Flags]             ,[MedianamikControlId]             ,[MedianamikControlWidth]             ,[MedianamikControlHeight]             ,[Position]             ,[PrimaryPropertyId]             ,[PrimaryTypeId]             ,[PrimaryMedianamikControlId]             ,[PrimaryMedianamikControlWidth]             ,[PrimaryMedianamikControlHeight]             ,[Roles]             ,[MaxLength]             ,[MinLength]             ,[DataTypeId]             ,[PrimaryDataTypeId]             ,[Description]             ,[TreeRootNodeId]             , [PrimaryTreeRootNodeId])       VALUES             ('4555C4BD-B476-4B47-943C-C4851345BFAB'             ,'0878439B-D784-4AB4-8104-28FB68263AA2'     , 'Description'     ,         0     ,         0     ,         0     ,         0     ,NULL     ,'Content'     ,         1     ,'AD890B8C-72ED-43A8-9B91-85F5B1B23BC0'     ,'90%'     ,300     ,         0     ,NULL     ,NULL     ,NULL     ,null     ,null     ,''     ,NULL     ,NULL     ,'D45C7AF5-3C9F-40CD-82FE-D09C03FAF7FE'     ,'0D5B7A19-A12A-46B5-9A2C-8D15093F5666'     ,''     ,NULL              ,NULL             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_Property where PropertyId = '72A8AC9E-13D8-41F9-9684-ED101A731BC7' )  BEGIN  INSERT INTO [dbo].[medianamik_Property]             ([PropertyId]             ,[TypeId]             ,[Name]             ,[HaveTooltip]             ,[IsLanguageNeutral]             ,[IsRequired]             ,[IsUnique]             ,[ValidationRegex]             ,[GroupName]             ,[Flags]             ,[MedianamikControlId]             ,[MedianamikControlWidth]             ,[MedianamikControlHeight]             ,[Position]             ,[PrimaryPropertyId]             ,[PrimaryTypeId]             ,[PrimaryMedianamikControlId]             ,[PrimaryMedianamikControlWidth]             ,[PrimaryMedianamikControlHeight]             ,[Roles]             ,[MaxLength]             ,[MinLength]             ,[DataTypeId]             ,[PrimaryDataTypeId]             ,[Description]             ,[TreeRootNodeId]             , [PrimaryTreeRootNodeId])       VALUES             ('72A8AC9E-13D8-41F9-9684-ED101A731BC7'             ,'0878439B-D784-4AB4-8104-28FB68263AA2'     , 'Configuration'     ,         0     ,         1     ,         1     ,         0     ,NULL     ,'Content'     ,         0     ,'59B66D0C-8BFF-4802-B83A-977E11797677'     ,'300px'     ,null     ,         0     ,'35A3F17A-A4C8-4331-9E8F-10FC27C18445'     ,'51E1110E-F0D4-4142-BD58-131C67BEA2A2'     ,NULL     ,null     ,null     ,''     ,NULL     ,NULL     ,'0D5B7A19-A12A-46B5-9A2C-8D15093F5666'     ,'0D5B7A19-A12A-46B5-9A2C-8D15093F5666'     ,''     ,NULL              ,NULL             )  END

-- Forum Group
IF NOT EXISTS( SELECT NULL  FROM medianamik_Type where TypeId = 'E542FDB3-17A0-4F64-9143-CCB86B1DC6B7')  BEGIN  INSERT INTO [dbo].[medianamik_Type]             ([TypeId]             ,[ParentTypeId]             ,[Name]             ,[CanHaveChilds]             ,[IsGenerated]             ,[IsManyToMany]             ,[Path]             ,[Depth]             ,[Roles]             ,[Flags]             ,[Description]             ,[ExtendedProperties]             ,[IsSystem]             ,[IsAbstract])       VALUES             ('E542FDB3-17A0-4F64-9143-CCB86B1DC6B7'             ,'F995444B-D7E2-4C3A-8F34-81953F1F1A42'             ,'ForumGroup'             ,         0             ,         1             ,         0             ,'.51942F57-8542-4D47-8E18-533BCDA9E4B6.30BA97AB-C437-4C85-8D9D-77FB428D3D16.F7757F24-42C8-4B50-8910-0828F8C8B96D.6A8FFFBC-03BE-4D06-9B98-CF2A093C4505.F995444B-D7E2-4C3A-8F34-81953F1F1A42.E542FDB3-17A0-4F64-9143-CCB86B1DC6B7.'             ,         5     ,NULL     ,         1             ,''     ,'<ExtendedProperties><Icon/></ExtendedProperties>'            ,         0     ,         0             )  END

-- Forum Post
IF NOT EXISTS( SELECT NULL  FROM medianamik_Type where TypeId = '02FB39D9-0CA4-4B65-932F-D94A22847AB4')  BEGIN  INSERT INTO [dbo].[medianamik_Type]             ([TypeId]             ,[ParentTypeId]             ,[Name]             ,[CanHaveChilds]             ,[IsGenerated]             ,[IsManyToMany]             ,[Path]             ,[Depth]             ,[Roles]             ,[Flags]             ,[Description]             ,[ExtendedProperties]             ,[IsSystem]             ,[IsAbstract])       VALUES             ('02FB39D9-0CA4-4B65-932F-D94A22847AB4'             ,'F995444B-D7E2-4C3A-8F34-81953F1F1A42'             ,'ForumPost'             ,         1             ,         1             ,         0             ,'.51942F57-8542-4D47-8E18-533BCDA9E4B6.30BA97AB-C437-4C85-8D9D-77FB428D3D16.F7757F24-42C8-4B50-8910-0828F8C8B96D.6A8FFFBC-03BE-4D06-9B98-CF2A093C4505.F995444B-D7E2-4C3A-8F34-81953F1F1A42.02FB39D9-0CA4-4B65-932F-D94A22847AB4.'             ,         5     ,NULL     ,         1             ,''     ,'<ExtendedProperties><Icon/></ExtendedProperties>'            ,         0     ,         0             )  END

-- Forum Thread
IF NOT EXISTS( SELECT NULL  FROM medianamik_Type where TypeId = '3A92A697-5A29-403E-AD21-90FBF9FEEC21')  BEGIN  INSERT INTO [dbo].[medianamik_Type]             ([TypeId]             ,[ParentTypeId]             ,[Name]             ,[CanHaveChilds]             ,[IsGenerated]             ,[IsManyToMany]             ,[Path]             ,[Depth]             ,[Roles]             ,[Flags]             ,[Description]             ,[ExtendedProperties]             ,[IsSystem]             ,[IsAbstract])       VALUES             ('3A92A697-5A29-403E-AD21-90FBF9FEEC21'             ,'F995444B-D7E2-4C3A-8F34-81953F1F1A42'             ,'ForumThread'             ,         1             ,         1             ,         0             ,'.51942F57-8542-4D47-8E18-533BCDA9E4B6.30BA97AB-C437-4C85-8D9D-77FB428D3D16.F7757F24-42C8-4B50-8910-0828F8C8B96D.6A8FFFBC-03BE-4D06-9B98-CF2A093C4505.F995444B-D7E2-4C3A-8F34-81953F1F1A42.3A92A697-5A29-403E-AD21-90FBF9FEEC21.'             ,         5     ,NULL     ,         1             ,''     ,'<ExtendedProperties><Icon/></ExtendedProperties>'            ,         0     ,         0             )  END

-- Noeud de configuration
IF NOT EXISTS( SELECT NULL  FROM medianamik_Node where NodeId = '9DC36990-1D1E-44AF-B36F-269EA9352C36')  BEGIN  INSERT INTO [dbo].[medianamik_Node]             ([NodeId]             ,[ParentNodeId]             ,[TypeId]             ,[CreatedOn]             ,[CreatedBy]             ,[ModifiedOn]             ,[ModifiedBy]             ,[Flags]             ,[IsDeleted]             ,[Path]             ,[Depth]             ,[Position]             ,[EditedOn]             ,[EditedBy])       VALUES             ('9DC36990-1D1E-44AF-B36F-269EA9352C36'             ,'6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78'                        ,'51E1110E-F0D4-4142-BD58-131C67BEA2A2'             ,'2009-07-14 14:39:25.527'             ,''             ,'2009-07-17 15:01:49.417'             ,''             ,         0             ,         0             ,'.6C09A5B6-D454-4BFA-BE7D-3AA1BB57AB78.9DC36990-1D1E-44AF-B36F-269EA9352C36.'             ,         1             ,         0             ,'2009-07-17 15:01:49.417'             ,'sa'             )  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '9DC36990-1D1E-44AF-B36F-269EA9352C36' AND CultureNAme = 'fr-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('759961A9-A476-416D-A88F-196D1BA8713B'             ,'9DC36990-1D1E-44AF-B36F-269EA9352C36'             ,         1             ,'2009-07-14 14:39:25.527'             ,'fr-CA')  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '9DC36990-1D1E-44AF-B36F-269EA9352C36' AND CultureNAme = 'en-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('1213EEB2-8DC6-4341-9709-2968E0412599'             ,'9DC36990-1D1E-44AF-B36F-269EA9352C36'             ,         1             ,'2009-07-17 15:01:49.433'             ,'en-CA')  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '9DC36990-1D1E-44AF-B36F-269EA9352C36' AND PropertyId = '35A3F17A-A4C8-4331-9E8F-10FC27C18445' AND CultureName = 'fr-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('9DC36990-1D1E-44AF-B36F-269EA9352C36'             ,'35A3F17A-A4C8-4331-9E8F-10FC27C18445'             ,'Test Configuration 3'                       ,null             ,'fr-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '9DC36990-1D1E-44AF-B36F-269EA9352C36' AND PropertyId = '35A3F17A-A4C8-4331-9E8F-10FC27C18445' AND CultureName = 'en-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('9DC36990-1D1E-44AF-B36F-269EA9352C36'             ,'35A3F17A-A4C8-4331-9E8F-10FC27C18445'             ,'Test Configuration 3'                       ,null             ,'en-CA'             ,null             )  END


-- Groupe ForumMember
if not exists(Select null from Medianamik_Group where GroupId = '8DEA16A6-81DD-4D9C-BE66-C48FB05DAFEF') begin insert into Medianamik_Group Values ('8DEA16A6-81DD-4D9C-BE66-C48FB05DAFEF', 'ForumMember') end
